package com.adminserver.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import java.util.Date;

import com.adminserver.entity.ApplyMaterialEntity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
 * @author anonymous
 * @description 针对表【apply_material(申报材料)】的数据库操作Mapper
 * @createDate 2022-04-24 19:22:54
 * @Entity com.adminserver.entity.ApplyMaterialEntity
 */
public interface ApplyMaterialMapper extends BaseMapper<ApplyMaterialEntity> {
    /**
     * 查询指定年范围内的收支情
     *
     * @param beginApplyTime
     * @param endApplyTime   结束日期时间
     * @return
     */
    List<ApplyMaterialEntity> queryMaterialPriceAndTakeAmountAndChargeOnByApplyTimeBetween(@Param("beginApplyTime") String beginApplyTime,
                                                                                           @Param("endApplyTime") String endApplyTime);

    /**
     * 查询指定年范围内的支
     *
     * @param beginApplyTime
     * @param endApplyTime   结束日期时间
     * @return
     */
    List<ApplyMaterialEntity> queryMaterialPriceAndTakeAmountByApplyTimeBetween(@Param("beginApplyTime") String beginApplyTime,
                                                                                @Param("endApplyTime") String endApplyTime);

    /**
     * 查询 指定年月范围内的总报修支
     * @param beginApplyTime
     * @param endApplyTime   结束日期时间
     * @return
     */
    float queryTotalWageByYearMonth(@Param("beginApplyTime") String beginApplyTime,
                                    @Param("endApplyTime") String endApplyTime);
}





